﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="instantgetDataSet" targetNamespace="http://tempuri.org/instantgetDataSet.xsd" xmlns:mstns="http://tempuri.org/instantgetDataSet.xsd" xmlns="http://tempuri.org/instantgetDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="instantgetConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="instantgetConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.instantget.Properties.Settings.GlobalReference.Default.instantgetConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="alkategoriaTableAdapter" GeneratorDataComponentClassName="alkategoriaTableAdapter" Name="alkategoria" UserDataComponentName="alkategoriaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="instantgetConnectionString (Settings)" DbObjectName="dbo.alkategoria" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[alkategoria] WHERE (([alkat_id] = @Original_alkat_id) AND ([alkat_nev] = @Original_alkat_nev) AND ([fokat_id] = @Original_fokat_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_alkat_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="alkat_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_alkat_nev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="alkat_nev" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_fokat_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fokat_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[alkategoria] ([alkat_nev], [fokat_id]) VALUES (@alkat_nev, @fokat_id);
SELECT alkat_id, alkat_nev, fokat_id FROM alkategoria WHERE (alkat_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@alkat_nev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="alkat_nev" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@fokat_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fokat_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT alkat_id, alkat_nev, fokat_id FROM dbo.alkategoria</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[alkategoria] SET [alkat_nev] = @alkat_nev, [fokat_id] = @fokat_id WHERE (([alkat_id] = @Original_alkat_id) AND ([alkat_nev] = @Original_alkat_nev) AND ([fokat_id] = @Original_fokat_id));
SELECT alkat_id, alkat_nev, fokat_id FROM alkategoria WHERE (alkat_id = @alkat_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@alkat_nev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="alkat_nev" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@fokat_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fokat_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_alkat_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="alkat_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_alkat_nev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="alkat_nev" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_fokat_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fokat_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="alkat_id" ColumnName="alkat_id" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@alkat_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="alkat_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="alkat_id" DataSetColumn="alkat_id" />
              <Mapping SourceColumn="alkat_nev" DataSetColumn="alkat_nev" />
              <Mapping SourceColumn="fokat_id" DataSetColumn="fokat_id" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="instantgetConnectionString (Settings)" DbObjectName="dbo.alkategoria" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFokategoria" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByFokategoria" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillByFokategoria">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        alkat_id, alkat_nev, fokat_id
FROM            alkategoria
WHERE        (fokat_id = @fid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="fid" ColumnName="fokat_id" DataSourceName="[C:\USERS\CSABEEKJ\DOCUMENTS\VISUAL STUDIO 2012\PROJECTS\INSTANTGET\INSTANTGET\INSTANTGET.MDF].dbo.alkategoria" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@fid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="fokat_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="fokategoriaTableAdapter" GeneratorDataComponentClassName="fokategoriaTableAdapter" Name="fokategoria" UserDataComponentName="fokategoriaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="instantgetConnectionString (Settings)" DbObjectName="dbo.fokategoria" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[fokategoria] WHERE (([fokat_id] = @Original_fokat_id) AND ([fokat_nev] = @Original_fokat_nev))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_fokat_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fokat_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fokat_nev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fokat_nev" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[fokategoria] ([fokat_nev]) VALUES (@fokat_nev);
SELECT fokat_id, fokat_nev FROM fokategoria WHERE (fokat_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fokat_nev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fokat_nev" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT fokat_id, fokat_nev FROM dbo.fokategoria</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[fokategoria] SET [fokat_nev] = @fokat_nev WHERE (([fokat_id] = @Original_fokat_id) AND ([fokat_nev] = @Original_fokat_nev));
SELECT fokat_id, fokat_nev FROM fokategoria WHERE (fokat_id = @fokat_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fokat_nev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fokat_nev" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_fokat_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fokat_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fokat_nev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fokat_nev" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="fokat_id" ColumnName="fokat_id" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@fokat_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="fokat_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="fokat_id" DataSetColumn="fokat_id" />
              <Mapping SourceColumn="fokat_nev" DataSetColumn="fokat_nev" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="kepTableAdapter" GeneratorDataComponentClassName="kepTableAdapter" Name="kep" UserDataComponentName="kepTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="instantgetConnectionString (Settings)" DbObjectName="dbo.kep" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[kep] WHERE (([kep_id] = @Original_kep_id) AND ([ta_id] = @Original_ta_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_kep_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="kep_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ta_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ta_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[kep] ([ta_id], [image]) VALUES (@ta_id, @image);
SELECT kep_id, ta_id, image FROM kep WHERE (kep_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ta_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ta_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@image" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="image" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT kep_id, ta_id, image FROM dbo.kep</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[kep] SET [ta_id] = @ta_id, [image] = @image WHERE (([kep_id] = @Original_kep_id) AND ([ta_id] = @Original_ta_id));
SELECT kep_id, ta_id, image FROM kep WHERE (kep_id = @kep_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ta_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ta_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@image" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="image" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_kep_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="kep_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ta_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ta_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="kep_id" ColumnName="kep_id" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@kep_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="kep_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="kep_id" DataSetColumn="kep_id" />
              <Mapping SourceColumn="ta_id" DataSetColumn="ta_id" />
              <Mapping SourceColumn="image" DataSetColumn="image" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="instantgetConnectionString (Settings)" DbObjectName="dbo.kep" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTargy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTargy" GeneratorSourceName="FillByTargy" GetMethodModifier="Public" GetMethodName="GetDataByTargy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTargy" UserSourceName="FillByTargy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        kep_id, ta_id, image
FROM            kep
WHERE        (ta_id = @targy)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="targy" ColumnName="ta_id" DataSourceName="[C:\USERS\CSABEEKJ\DOCUMENTS\VISUAL STUDIO 2012\PROJECTS\INSTANTGET\INSTANTGET\INSTANTGET.MDF].dbo.kep" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@targy" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ta_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="licittargyTableAdapter" GeneratorDataComponentClassName="licittargyTableAdapter" Name="licittargy" UserDataComponentName="licittargyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="instantgetConnectionString (Settings)" DbObjectName="dbo.licittargy" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[licittargy] WHERE (([ta_id] = @Original_ta_id) AND ([ta_nev] = @Original_ta_nev) AND ((@IsNull_aukc_kezdet = 1 AND [aukc_kezdet] IS NULL) OR ([aukc_kezdet] = @Original_aukc_kezdet)) AND ([auck_veg] = @Original_auck_veg) AND ([alkat_id] = @Original_alkat_id) AND ((@IsNull_kivasarlas_ar = 1 AND [kivasarlas_ar] IS NULL) OR ([kivasarlas_ar] = @Original_kivasarlas_ar)) AND ((@IsNull_elkelt = 1 AND [elkelt] IS NULL) OR ([elkelt] = @Original_elkelt)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ta_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ta_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ta_nev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ta_nev" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_aukc_kezdet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="aukc_kezdet" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_aukc_kezdet" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="aukc_kezdet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_auck_veg" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="auck_veg" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_alkat_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="alkat_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_kivasarlas_ar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="kivasarlas_ar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_kivasarlas_ar" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="kivasarlas_ar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_elkelt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="elkelt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_elkelt" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="elkelt" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[licittargy] ([ta_nev], [aukc_kezdet], [auck_veg], [egyeb], [alkat_id], [kivasarlas_ar], [elkelt]) VALUES (@ta_nev, @aukc_kezdet, @auck_veg, @egyeb, @alkat_id, @kivasarlas_ar, @elkelt);
SELECT ta_id, ta_nev, aukc_kezdet, auck_veg, egyeb, alkat_id, kivasarlas_ar, elkelt FROM licittargy WHERE (ta_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ta_nev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ta_nev" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@aukc_kezdet" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="aukc_kezdet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@auck_veg" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="auck_veg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@egyeb" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="egyeb" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@alkat_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="alkat_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@kivasarlas_ar" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="kivasarlas_ar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@elkelt" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="elkelt" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ta_id, ta_nev, aukc_kezdet, auck_veg, egyeb, alkat_id, kivasarlas_ar, elkelt FROM dbo.licittargy</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[licittargy] SET [ta_nev] = @ta_nev, [aukc_kezdet] = @aukc_kezdet, [auck_veg] = @auck_veg, [egyeb] = @egyeb, [alkat_id] = @alkat_id, [kivasarlas_ar] = @kivasarlas_ar, [elkelt] = @elkelt WHERE (([ta_id] = @Original_ta_id) AND ([ta_nev] = @Original_ta_nev) AND ((@IsNull_aukc_kezdet = 1 AND [aukc_kezdet] IS NULL) OR ([aukc_kezdet] = @Original_aukc_kezdet)) AND ([auck_veg] = @Original_auck_veg) AND ([alkat_id] = @Original_alkat_id) AND ((@IsNull_kivasarlas_ar = 1 AND [kivasarlas_ar] IS NULL) OR ([kivasarlas_ar] = @Original_kivasarlas_ar)) AND ((@IsNull_elkelt = 1 AND [elkelt] IS NULL) OR ([elkelt] = @Original_elkelt)));
SELECT ta_id, ta_nev, aukc_kezdet, auck_veg, egyeb, alkat_id, kivasarlas_ar, elkelt FROM licittargy WHERE (ta_id = @ta_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ta_nev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ta_nev" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@aukc_kezdet" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="aukc_kezdet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@auck_veg" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="auck_veg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@egyeb" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="egyeb" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@alkat_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="alkat_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@kivasarlas_ar" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="kivasarlas_ar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@elkelt" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="elkelt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ta_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ta_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ta_nev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ta_nev" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_aukc_kezdet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="aukc_kezdet" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_aukc_kezdet" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="aukc_kezdet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_auck_veg" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="auck_veg" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_alkat_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="alkat_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_kivasarlas_ar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="kivasarlas_ar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_kivasarlas_ar" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="kivasarlas_ar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_elkelt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="elkelt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_elkelt" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="elkelt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ta_id" ColumnName="ta_id" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ta_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ta_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ta_id" DataSetColumn="ta_id" />
              <Mapping SourceColumn="ta_nev" DataSetColumn="ta_nev" />
              <Mapping SourceColumn="aukc_kezdet" DataSetColumn="aukc_kezdet" />
              <Mapping SourceColumn="auck_veg" DataSetColumn="auck_veg" />
              <Mapping SourceColumn="egyeb" DataSetColumn="egyeb" />
              <Mapping SourceColumn="alkat_id" DataSetColumn="alkat_id" />
              <Mapping SourceColumn="kivasarlas_ar" DataSetColumn="kivasarlas_ar" />
              <Mapping SourceColumn="elkelt" DataSetColumn="elkelt" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="instantgetConnectionString (Settings)" DbObjectName="dbo.licittargy" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCurrentUser" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCurrentUser" GeneratorSourceName="FillByCurrentUser" GetMethodModifier="Public" GetMethodName="GetDataByCurrentUser" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCurrentUser" UserSourceName="FillByCurrentUser">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        licittargy.ta_id, licittargy.ta_nev, licittargy.aukc_kezdet, licittargy.auck_veg, licittargy.egyeb, licittargy.alkat_id, licittargy.kivasarlas_ar, licittargy.elkelt
FROM            licittargy INNER JOIN
                         licit ON licittargy.ta_id = licit.ta_id
WHERE        (licit.nnev = @CurrUser) AND (licit.pw = @CurrPass) AND (licit.tulaj = 1) AND (licittargy.elkelt = @elkelt)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CurrUser" ColumnName="nnev" DataSourceName="[C:\USERS\CSABEEKJ\DOCUMENTS\VISUAL STUDIO 2012\PROJECTS\INSTANTGET\INSTANTGET\INSTANTGET.MDF].dbo.licit" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@CurrUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="nnev" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CurrPass" ColumnName="pw" DataSourceName="[C:\USERS\CSABEEKJ\DOCUMENTS\VISUAL STUDIO 2012\PROJECTS\INSTANTGET\INSTANTGET\INSTANTGET.MDF].dbo.licit" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CurrPass" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="pw" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="elkelt" ColumnName="elkelt" DataSourceName="[C:\USERS\CSABEEKJ\DOCUMENTS\VISUAL STUDIO 2012\PROJECTS\INSTANTGET\INSTANTGET\INSTANTGET.MDF].dbo.licittargy" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@elkelt" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="elkelt" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="instantgetConnectionString (Settings)" DbObjectName="dbo.licittargy" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByKereses" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByKereses" GeneratorSourceName="FillByKereses" GetMethodModifier="Public" GetMethodName="GetDataByKereses" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByKereses" UserSourceName="FillByKereses">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        licittargy.ta_id, licittargy.ta_nev, licittargy.auck_veg, licittargy.egyeb, licittargy.kivasarlas_ar, licittargy.elkelt, MAX(licit.licit_ar) AS licit_ar, licittargy.aukc_kezdet, 
                         licittargy.alkat_id
FROM            licittargy INNER JOIN
                         licit ON licittargy.ta_id = licit.ta_id
WHERE        (licittargy.aukc_kezdet &gt; @also) AND (licittargy.alkat_id = @aid)
GROUP BY licittargy.ta_id, licittargy.ta_nev, licittargy.auck_veg, licittargy.egyeb, licittargy.kivasarlas_ar, licittargy.elkelt, licittargy.aukc_kezdet, licittargy.alkat_id
HAVING        (licittargy.ta_nev LIKE N'%' + @tnev + N'%') AND (licittargy.auck_veg &lt; @felso) AND (licittargy.elkelt = 0)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="also" ColumnName="aukc_kezdet" DataSourceName="[C:\USERS\CSABEEKJ\DOCUMENTS\VISUAL STUDIO 2012\PROJECTS\INSTANTGET\INSTANTGET\INSTANTGET.MDF].dbo.licittargy" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@also" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="aukc_kezdet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="aid" ColumnName="alkat_id" DataSourceName="[C:\USERS\CSABEEKJ\DOCUMENTS\VISUAL STUDIO 2012\PROJECTS\INSTANTGET\INSTANTGET\INSTANTGET.MDF].dbo.licittargy" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@aid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="alkat_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="tnev" ColumnName="ta_nev" DataSourceName="[C:\USERS\CSABEEKJ\DOCUMENTS\VISUAL STUDIO 2012\PROJECTS\INSTANTGET\INSTANTGET\INSTANTGET.MDF].dbo.licittargy" DataTypeServer="nvarchar(75)" DbType="String" Direction="Input" ParameterName="@tnev" Precision="0" ProviderType="NVarChar" Scale="0" Size="75" SourceColumn="ta_nev" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="felso" ColumnName="auck_veg" DataSourceName="[C:\USERS\CSABEEKJ\DOCUMENTS\VISUAL STUDIO 2012\PROJECTS\INSTANTGET\INSTANTGET\INSTANTGET.MDF].dbo.licittargy" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@felso" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="auck_veg" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="instantgetConnectionString (Settings)" DbObjectName="dbo.licittargy" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByKeresNoKat" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByKeresNoKat" GeneratorSourceName="FillByKeresNoKat" GetMethodModifier="Public" GetMethodName="GetDataByKeresNoKat" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByKeresNoKat" UserSourceName="FillByKeresNoKat">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        licittargy.ta_id, licittargy.ta_nev, licittargy.auck_veg, licittargy.egyeb, licittargy.kivasarlas_ar, licittargy.elkelt, MAX(licit.licit_ar) AS licit_ar, 
                         licittargy.aukc_kezdet
FROM            licittargy INNER JOIN
                         licit ON licittargy.ta_id = licit.ta_id
WHERE        (licittargy.aukc_kezdet &gt; @also)
GROUP BY licittargy.ta_id, licittargy.ta_nev, licittargy.auck_veg, licittargy.egyeb, licittargy.kivasarlas_ar, licittargy.elkelt, licittargy.aukc_kezdet
HAVING        (licittargy.ta_nev LIKE N'%' + @tnev + N'%') AND (licittargy.auck_veg &lt; @felso) AND (licittargy.elkelt = 0)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="also" ColumnName="aukc_kezdet" DataSourceName="[C:\USERS\CSABEEKJ\DOCUMENTS\VISUAL STUDIO 2012\PROJECTS\INSTANTGET\INSTANTGET\INSTANTGET.MDF].dbo.licittargy" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@also" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="aukc_kezdet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="tnev" ColumnName="ta_nev" DataSourceName="[C:\USERS\CSABEEKJ\DOCUMENTS\VISUAL STUDIO 2012\PROJECTS\INSTANTGET\INSTANTGET\INSTANTGET.MDF].dbo.licittargy" DataTypeServer="nvarchar(75)" DbType="String" Direction="Input" ParameterName="@tnev" Precision="0" ProviderType="NVarChar" Scale="0" Size="75" SourceColumn="ta_nev" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="felso" ColumnName="auck_veg" DataSourceName="[C:\USERS\CSABEEKJ\DOCUMENTS\VISUAL STUDIO 2012\PROJECTS\INSTANTGET\INSTANTGET\INSTANTGET.MDF].dbo.licittargy" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@felso" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="auck_veg" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="varosTableAdapter" GeneratorDataComponentClassName="varosTableAdapter" Name="varos" UserDataComponentName="varosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="instantgetConnectionString (Settings)" DbObjectName="dbo.varos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[varos] WHERE (([varos_id] = @Original_varos_id) AND ([varos_nev] = @Original_varos_nev))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_varos_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="varos_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_varos_nev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="varos_nev" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[varos] ([varos_nev]) VALUES (@varos_nev);
SELECT varos_id, varos_nev FROM varos WHERE (varos_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@varos_nev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="varos_nev" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT varos_id, varos_nev FROM dbo.varos</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[varos] SET [varos_nev] = @varos_nev WHERE (([varos_id] = @Original_varos_id) AND ([varos_nev] = @Original_varos_nev));
SELECT varos_id, varos_nev FROM varos WHERE (varos_id = @varos_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@varos_nev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="varos_nev" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_varos_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="varos_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_varos_nev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="varos_nev" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="varos_id" ColumnName="varos_id" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@varos_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="varos_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="varos_id" DataSetColumn="varos_id" />
              <Mapping SourceColumn="varos_nev" DataSetColumn="varos_nev" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="felhasznaloTableAdapter" GeneratorDataComponentClassName="felhasznaloTableAdapter" Name="felhasznalo" UserDataComponentName="felhasznaloTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="instantgetConnectionString (Settings)" DbObjectName="dbo.felhasznalo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[felhasznalo] WHERE (([pw] = @Original_pw) AND ([nnev] = @Original_nnev) AND ([knev] = @Original_knev) AND ([vnev] = @Original_vnev) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ([varos_id] = @Original_varos_id) AND ([irszam] = @Original_irszam) AND ([cim] = @Original_cim) AND ((@IsNull_tel = 1 AND [tel] IS NULL) OR ([tel] = @Original_tel)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_pw" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pw" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nnev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nnev" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_knev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="knev" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_vnev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="vnev" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_varos_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="varos_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_irszam" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="irszam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cim" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cim" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_tel" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tel" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[felhasznalo] ([pw], [nnev], [knev], [vnev], [email], [varos_id], [irszam], [cim], [tel]) VALUES (@pw, @nnev, @knev, @vnev, @email, @varos_id, @irszam, @cim, @tel);
SELECT pw, nnev, knev, vnev, email, varos_id, irszam, cim, tel FROM felhasznalo WHERE (nnev = @nnev) AND (pw = @pw)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@pw" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pw" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nnev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nnev" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@knev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="knev" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@vnev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="vnev" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@varos_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="varos_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@irszam" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="irszam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cim" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cim" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@tel" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tel" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT pw, nnev, knev, vnev, email, varos_id, irszam, cim, tel FROM dbo.felhasznalo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[felhasznalo] SET [pw] = @pw, [nnev] = @nnev, [knev] = @knev, [vnev] = @vnev, [email] = @email, [varos_id] = @varos_id, [irszam] = @irszam, [cim] = @cim, [tel] = @tel WHERE (([pw] = @Original_pw) AND ([nnev] = @Original_nnev) AND ([knev] = @Original_knev) AND ([vnev] = @Original_vnev) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ([varos_id] = @Original_varos_id) AND ([irszam] = @Original_irszam) AND ([cim] = @Original_cim) AND ((@IsNull_tel = 1 AND [tel] IS NULL) OR ([tel] = @Original_tel)));
SELECT pw, nnev, knev, vnev, email, varos_id, irszam, cim, tel FROM felhasznalo WHERE (nnev = @nnev) AND (pw = @pw)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@pw" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pw" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nnev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nnev" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@knev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="knev" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@vnev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="vnev" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@varos_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="varos_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@irszam" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="irszam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cim" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cim" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@tel" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_pw" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pw" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nnev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nnev" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_knev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="knev" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_vnev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="vnev" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_varos_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="varos_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_irszam" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="irszam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cim" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cim" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_tel" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tel" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="pw" DataSetColumn="pw" />
              <Mapping SourceColumn="nnev" DataSetColumn="nnev" />
              <Mapping SourceColumn="knev" DataSetColumn="knev" />
              <Mapping SourceColumn="vnev" DataSetColumn="vnev" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
              <Mapping SourceColumn="varos_id" DataSetColumn="varos_id" />
              <Mapping SourceColumn="irszam" DataSetColumn="irszam" />
              <Mapping SourceColumn="cim" DataSetColumn="cim" />
              <Mapping SourceColumn="tel" DataSetColumn="tel" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="instantgetConnectionString (Settings)" DbObjectName="dbo.felhasznalo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUser" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByUser" GeneratorSourceName="FillByUser" GetMethodModifier="Public" GetMethodName="GetDataByUser" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByUser" UserSourceName="FillByUser">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        pw, nnev, knev, vnev, email, varos_id, irszam, cim, tel
FROM            felhasznalo
WHERE        (pw = @pw) AND (nnev = @nnev)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="pw" ColumnName="pw" DataSourceName="[C:\USERS\ÁKOS\EGYETEM\V.FÉLÉV\IRF\INSTANTGET\INSTANTGET\INSTANTGET.MDF].dbo.felhasznalo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pw" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="pw" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nnev" ColumnName="nnev" DataSourceName="[C:\USERS\ÁKOS\EGYETEM\V.FÉLÉV\IRF\INSTANTGET\INSTANTGET\INSTANTGET.MDF].dbo.felhasznalo" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@nnev" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="nnev" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="licitTableAdapter" GeneratorDataComponentClassName="licitTableAdapter" Name="licit" UserDataComponentName="licitTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="instantgetConnectionString (Settings)" DbObjectName="dbo.licit" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[licit] ([ta_id], [pw], [nnev], [idobelyeg], [licit_ar], [tulaj]) VALUES (@ta_id, @pw, @nnev, @idobelyeg, @licit_ar, @tulaj)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ta_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ta_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@pw" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pw" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nnev" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nnev" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@idobelyeg" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="idobelyeg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@licit_ar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="licit_ar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@tulaj" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="tulaj" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT licit_id, ta_id, pw, nnev, idobelyeg, licit_ar, tulaj FROM dbo.licit</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="licit_id" DataSetColumn="licit_id" />
              <Mapping SourceColumn="ta_id" DataSetColumn="ta_id" />
              <Mapping SourceColumn="pw" DataSetColumn="pw" />
              <Mapping SourceColumn="nnev" DataSetColumn="nnev" />
              <Mapping SourceColumn="idobelyeg" DataSetColumn="idobelyeg" />
              <Mapping SourceColumn="licit_ar" DataSetColumn="licit_ar" />
              <Mapping SourceColumn="tulaj" DataSetColumn="tulaj" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="instantgetConnectionString (Settings)" DbObjectName="dbo.licit" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTargy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTargy" GeneratorSourceName="FillByTargy" GetMethodModifier="Public" GetMethodName="GetDataByTargy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTargy" UserSourceName="FillByTargy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        licit_id, ta_id, pw, nnev, idobelyeg, licit_ar,tulaj
FROM            licit
WHERE        (ta_id = @targy)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="targy" ColumnName="ta_id" DataSourceName="[C:\USERS\CSABEEKJ\DOCUMENTS\VISUAL STUDIO 2012\PROJECTS\INSTANTGET\INSTANTGET\INSTANTGET.MDF].dbo.licit" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@targy" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ta_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LicitalokVevokTableAdapter" GeneratorDataComponentClassName="LicitalokVevokTableAdapter" Name="LicitalokVevok" UserDataComponentName="LicitalokVevokTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="instantgetConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        licit.licit_id, licit.idobelyeg, felhasznalo.knev, felhasznalo.vnev, felhasznalo.email, felhasznalo.irszam, felhasznalo.cim, felhasznalo.tel, varos.varos_nev, 
                         licit.licit_ar
FROM            licit INNER JOIN
                         felhasznalo ON licit.pw = felhasznalo.pw AND licit.nnev = felhasznalo.nnev INNER JOIN
                         varos ON felhasznalo.varos_id = varos.varos_id
WHERE        (licit.ta_id = @taid) AND (licit.tulaj = 0)
ORDER BY licit.idobelyeg</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="taid" ColumnName="ta_id" DataSourceName="[C:\USERS\CSABEEKJ\DOCUMENTS\VISUAL STUDIO 2012\PROJECTS\INSTANTGET\INSTANTGET\INSTANTGET.MDF].dbo.licit" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@taid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ta_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="licit_id" DataSetColumn="licit_id" />
              <Mapping SourceColumn="idobelyeg" DataSetColumn="idobelyeg" />
              <Mapping SourceColumn="knev" DataSetColumn="knev" />
              <Mapping SourceColumn="vnev" DataSetColumn="vnev" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
              <Mapping SourceColumn="irszam" DataSetColumn="irszam" />
              <Mapping SourceColumn="cim" DataSetColumn="cim" />
              <Mapping SourceColumn="tel" DataSetColumn="tel" />
              <Mapping SourceColumn="varos_nev" DataSetColumn="varos_nev" />
              <Mapping SourceColumn="licit_ar" DataSetColumn="licit_ar" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="instantgetConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByVevok" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByVevok" GeneratorSourceName="FillByVevok" GetMethodModifier="Public" GetMethodName="GetDataByVevok" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByVevok" UserSourceName="FillByVevok">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        TOP (1) licit.licit_id, licit.idobelyeg, felhasznalo.knev, felhasznalo.vnev, felhasznalo.email, felhasznalo.irszam, felhasznalo.cim, felhasznalo.tel, varos.varos_nev, 
                         licit.licit_ar
FROM            licit INNER JOIN
                         felhasznalo ON licit.pw = felhasznalo.pw AND licit.nnev = felhasznalo.nnev INNER JOIN
                         varos ON felhasznalo.varos_id = varos.varos_id
WHERE        (licit.ta_id = @taid) AND (licit.tulaj = 1)
ORDER BY licit.idobelyeg DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="taid" ColumnName="ta_id" DataSourceName="[C:\USERS\CSABEEKJ\DOCUMENTS\VISUAL STUDIO 2012\PROJECTS\INSTANTGET\INSTANTGET\INSTANTGET.MDF].dbo.licit" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@taid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ta_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="instantgetDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="instantgetDataSet" msprop:Generator_UserDSName="instantgetDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="alkategoria" msprop:Generator_TableClassName="alkategoriaDataTable" msprop:Generator_TableVarName="tablealkategoria" msprop:Generator_TablePropName="alkategoria" msprop:Generator_RowDeletingName="alkategoriaRowDeleting" msprop:Generator_RowChangingName="alkategoriaRowChanging" msprop:Generator_RowEvHandlerName="alkategoriaRowChangeEventHandler" msprop:Generator_RowDeletedName="alkategoriaRowDeleted" msprop:Generator_UserTableName="alkategoria" msprop:Generator_RowChangedName="alkategoriaRowChanged" msprop:Generator_RowEvArgName="alkategoriaRowChangeEvent" msprop:Generator_RowClassName="alkategoriaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="alkat_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnalkat_id" msprop:Generator_ColumnPropNameInRow="alkat_id" msprop:Generator_ColumnPropNameInTable="alkat_idColumn" msprop:Generator_UserColumnName="alkat_id" type="xs:int" />
              <xs:element name="alkat_nev" msprop:Generator_ColumnVarNameInTable="columnalkat_nev" msprop:Generator_ColumnPropNameInRow="alkat_nev" msprop:Generator_ColumnPropNameInTable="alkat_nevColumn" msprop:Generator_UserColumnName="alkat_nev">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fokat_id" msprop:Generator_ColumnVarNameInTable="columnfokat_id" msprop:Generator_ColumnPropNameInRow="fokat_id" msprop:Generator_ColumnPropNameInTable="fokat_idColumn" msprop:Generator_UserColumnName="fokat_id" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="fokategoria" msprop:Generator_TableClassName="fokategoriaDataTable" msprop:Generator_TableVarName="tablefokategoria" msprop:Generator_TablePropName="fokategoria" msprop:Generator_RowDeletingName="fokategoriaRowDeleting" msprop:Generator_RowChangingName="fokategoriaRowChanging" msprop:Generator_RowEvHandlerName="fokategoriaRowChangeEventHandler" msprop:Generator_RowDeletedName="fokategoriaRowDeleted" msprop:Generator_UserTableName="fokategoria" msprop:Generator_RowChangedName="fokategoriaRowChanged" msprop:Generator_RowEvArgName="fokategoriaRowChangeEvent" msprop:Generator_RowClassName="fokategoriaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="fokat_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnfokat_id" msprop:Generator_ColumnPropNameInRow="fokat_id" msprop:Generator_ColumnPropNameInTable="fokat_idColumn" msprop:Generator_UserColumnName="fokat_id" type="xs:int" />
              <xs:element name="fokat_nev" msprop:Generator_ColumnVarNameInTable="columnfokat_nev" msprop:Generator_ColumnPropNameInRow="fokat_nev" msprop:Generator_ColumnPropNameInTable="fokat_nevColumn" msprop:Generator_UserColumnName="fokat_nev">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="35" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="kep" msprop:Generator_TableClassName="kepDataTable" msprop:Generator_TableVarName="tablekep" msprop:Generator_TablePropName="kep" msprop:Generator_RowDeletingName="kepRowDeleting" msprop:Generator_RowChangingName="kepRowChanging" msprop:Generator_RowEvHandlerName="kepRowChangeEventHandler" msprop:Generator_RowDeletedName="kepRowDeleted" msprop:Generator_UserTableName="kep" msprop:Generator_RowChangedName="kepRowChanged" msprop:Generator_RowEvArgName="kepRowChangeEvent" msprop:Generator_RowClassName="kepRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="kep_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnkep_id" msprop:Generator_ColumnPropNameInRow="kep_id" msprop:Generator_ColumnPropNameInTable="kep_idColumn" msprop:Generator_UserColumnName="kep_id" type="xs:int" />
              <xs:element name="ta_id" msprop:Generator_ColumnVarNameInTable="columnta_id" msprop:Generator_ColumnPropNameInRow="ta_id" msprop:Generator_ColumnPropNameInTable="ta_idColumn" msprop:Generator_UserColumnName="ta_id" type="xs:int" />
              <xs:element name="image" msprop:Generator_ColumnVarNameInTable="columnimage" msprop:Generator_ColumnPropNameInRow="image" msprop:Generator_ColumnPropNameInTable="imageColumn" msprop:Generator_UserColumnName="image" type="xs:base64Binary" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="licittargy" msprop:Generator_TableClassName="licittargyDataTable" msprop:Generator_TableVarName="tablelicittargy" msprop:Generator_TablePropName="licittargy" msprop:Generator_RowDeletingName="licittargyRowDeleting" msprop:Generator_RowChangingName="licittargyRowChanging" msprop:Generator_RowEvHandlerName="licittargyRowChangeEventHandler" msprop:Generator_RowDeletedName="licittargyRowDeleted" msprop:Generator_UserTableName="licittargy" msprop:Generator_RowChangedName="licittargyRowChanged" msprop:Generator_RowEvArgName="licittargyRowChangeEvent" msprop:Generator_RowClassName="licittargyRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ta_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnta_id" msprop:Generator_ColumnPropNameInRow="ta_id" msprop:Generator_ColumnPropNameInTable="ta_idColumn" msprop:Generator_UserColumnName="ta_id" type="xs:int" />
              <xs:element name="ta_nev" msprop:Generator_ColumnVarNameInTable="columnta_nev" msprop:Generator_ColumnPropNameInRow="ta_nev" msprop:Generator_ColumnPropNameInTable="ta_nevColumn" msprop:Generator_UserColumnName="ta_nev">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="75" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="aukc_kezdet" msprop:Generator_ColumnVarNameInTable="columnaukc_kezdet" msprop:Generator_ColumnPropNameInRow="aukc_kezdet" msprop:Generator_ColumnPropNameInTable="aukc_kezdetColumn" msprop:Generator_UserColumnName="aukc_kezdet" type="xs:dateTime" minOccurs="0" />
              <xs:element name="auck_veg" msprop:Generator_ColumnVarNameInTable="columnauck_veg" msprop:Generator_ColumnPropNameInRow="auck_veg" msprop:Generator_ColumnPropNameInTable="auck_vegColumn" msprop:Generator_UserColumnName="auck_veg" type="xs:dateTime" />
              <xs:element name="egyeb" msprop:Generator_ColumnVarNameInTable="columnegyeb" msprop:Generator_ColumnPropNameInRow="egyeb" msprop:Generator_ColumnPropNameInTable="egyebColumn" msprop:Generator_UserColumnName="egyeb" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="alkat_id" msprop:Generator_ColumnVarNameInTable="columnalkat_id" msprop:Generator_ColumnPropNameInRow="alkat_id" msprop:Generator_ColumnPropNameInTable="alkat_idColumn" msprop:Generator_UserColumnName="alkat_id" type="xs:int" />
              <xs:element name="kivasarlas_ar" msprop:Generator_ColumnVarNameInTable="columnkivasarlas_ar" msprop:Generator_ColumnPropNameInRow="kivasarlas_ar" msprop:Generator_ColumnPropNameInTable="kivasarlas_arColumn" msprop:Generator_UserColumnName="kivasarlas_ar" type="xs:int" minOccurs="0" />
              <xs:element name="elkelt" msprop:Generator_ColumnVarNameInTable="columnelkelt" msprop:Generator_ColumnPropNameInRow="elkelt" msprop:Generator_ColumnPropNameInTable="elkeltColumn" msprop:Generator_UserColumnName="elkelt" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="varos" msprop:Generator_TableClassName="varosDataTable" msprop:Generator_TableVarName="tablevaros" msprop:Generator_TablePropName="varos" msprop:Generator_RowDeletingName="varosRowDeleting" msprop:Generator_RowChangingName="varosRowChanging" msprop:Generator_RowEvHandlerName="varosRowChangeEventHandler" msprop:Generator_RowDeletedName="varosRowDeleted" msprop:Generator_UserTableName="varos" msprop:Generator_RowChangedName="varosRowChanged" msprop:Generator_RowEvArgName="varosRowChangeEvent" msprop:Generator_RowClassName="varosRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="varos_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnvaros_id" msprop:Generator_ColumnPropNameInRow="varos_id" msprop:Generator_ColumnPropNameInTable="varos_idColumn" msprop:Generator_UserColumnName="varos_id" type="xs:int" />
              <xs:element name="varos_nev" msprop:Generator_ColumnVarNameInTable="columnvaros_nev" msprop:Generator_ColumnPropNameInRow="varos_nev" msprop:Generator_ColumnPropNameInTable="varos_nevColumn" msprop:Generator_UserColumnName="varos_nev">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="felhasznalo" msprop:Generator_TableClassName="felhasznaloDataTable" msprop:Generator_TableVarName="tablefelhasznalo" msprop:Generator_TablePropName="felhasznalo" msprop:Generator_RowDeletingName="felhasznaloRowDeleting" msprop:Generator_RowChangingName="felhasznaloRowChanging" msprop:Generator_RowEvHandlerName="felhasznaloRowChangeEventHandler" msprop:Generator_RowDeletedName="felhasznaloRowDeleted" msprop:Generator_UserTableName="felhasznalo" msprop:Generator_RowChangedName="felhasznaloRowChanged" msprop:Generator_RowEvArgName="felhasznaloRowChangeEvent" msprop:Generator_RowClassName="felhasznaloRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="pw" msprop:Generator_ColumnVarNameInTable="columnpw" msprop:Generator_ColumnPropNameInRow="pw" msprop:Generator_ColumnPropNameInTable="pwColumn" msprop:Generator_UserColumnName="pw" type="xs:int" />
              <xs:element name="nnev" msprop:Generator_ColumnVarNameInTable="columnnnev" msprop:Generator_ColumnPropNameInRow="nnev" msprop:Generator_ColumnPropNameInTable="nnevColumn" msprop:Generator_UserColumnName="nnev">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="knev" msprop:Generator_ColumnVarNameInTable="columnknev" msprop:Generator_ColumnPropNameInRow="knev" msprop:Generator_ColumnPropNameInTable="knevColumn" msprop:Generator_UserColumnName="knev">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="vnev" msprop:Generator_ColumnVarNameInTable="columnvnev" msprop:Generator_ColumnPropNameInRow="vnev" msprop:Generator_ColumnPropNameInTable="vnevColumn" msprop:Generator_UserColumnName="vnev">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="varos_id" msprop:Generator_ColumnVarNameInTable="columnvaros_id" msprop:Generator_ColumnPropNameInRow="varos_id" msprop:Generator_ColumnPropNameInTable="varos_idColumn" msprop:Generator_UserColumnName="varos_id" type="xs:int" />
              <xs:element name="irszam" msprop:Generator_ColumnVarNameInTable="columnirszam" msprop:Generator_ColumnPropNameInRow="irszam" msprop:Generator_ColumnPropNameInTable="irszamColumn" msprop:Generator_UserColumnName="irszam">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cim" msprop:Generator_ColumnVarNameInTable="columncim" msprop:Generator_ColumnPropNameInRow="cim" msprop:Generator_ColumnPropNameInTable="cimColumn" msprop:Generator_UserColumnName="cim">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tel" msprop:Generator_ColumnVarNameInTable="columntel" msprop:Generator_ColumnPropNameInRow="tel" msprop:Generator_ColumnPropNameInTable="telColumn" msprop:Generator_UserColumnName="tel" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="licit" msprop:Generator_TableClassName="licitDataTable" msprop:Generator_TableVarName="tablelicit" msprop:Generator_RowChangedName="licitRowChanged" msprop:Generator_TablePropName="licit" msprop:Generator_RowDeletingName="licitRowDeleting" msprop:Generator_RowChangingName="licitRowChanging" msprop:Generator_RowEvHandlerName="licitRowChangeEventHandler" msprop:Generator_RowDeletedName="licitRowDeleted" msprop:Generator_RowClassName="licitRow" msprop:Generator_UserTableName="licit" msprop:Generator_RowEvArgName="licitRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="licit_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnlicit_id" msprop:Generator_ColumnPropNameInRow="licit_id" msprop:Generator_ColumnPropNameInTable="licit_idColumn" msprop:Generator_UserColumnName="licit_id" type="xs:int" />
              <xs:element name="ta_id" msprop:Generator_ColumnVarNameInTable="columnta_id" msprop:Generator_ColumnPropNameInRow="ta_id" msprop:Generator_ColumnPropNameInTable="ta_idColumn" msprop:Generator_UserColumnName="ta_id" type="xs:int" />
              <xs:element name="pw" msprop:Generator_ColumnVarNameInTable="columnpw" msprop:Generator_ColumnPropNameInRow="pw" msprop:Generator_ColumnPropNameInTable="pwColumn" msprop:Generator_UserColumnName="pw" type="xs:int" />
              <xs:element name="nnev" msprop:Generator_ColumnVarNameInTable="columnnnev" msprop:Generator_ColumnPropNameInRow="nnev" msprop:Generator_ColumnPropNameInTable="nnevColumn" msprop:Generator_UserColumnName="nnev">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="idobelyeg" msprop:Generator_ColumnVarNameInTable="columnidobelyeg" msprop:Generator_ColumnPropNameInRow="idobelyeg" msprop:Generator_ColumnPropNameInTable="idobelyegColumn" msprop:Generator_UserColumnName="idobelyeg" type="xs:dateTime" />
              <xs:element name="licit_ar" msprop:Generator_ColumnVarNameInTable="columnlicit_ar" msprop:Generator_ColumnPropNameInRow="licit_ar" msprop:Generator_ColumnPropNameInTable="licit_arColumn" msprop:Generator_UserColumnName="licit_ar" type="xs:int" />
              <xs:element name="tulaj" msprop:Generator_ColumnVarNameInTable="columntulaj" msprop:Generator_ColumnPropNameInRow="tulaj" msprop:Generator_ColumnPropNameInTable="tulajColumn" msprop:Generator_UserColumnName="tulaj" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="LicitalokVevok" msprop:Generator_TableClassName="LicitalokVevokDataTable" msprop:Generator_TableVarName="tableLicitalokVevok" msprop:Generator_TablePropName="LicitalokVevok" msprop:Generator_RowDeletingName="LicitalokVevokRowDeleting" msprop:Generator_RowChangingName="LicitalokVevokRowChanging" msprop:Generator_RowEvHandlerName="LicitalokVevokRowChangeEventHandler" msprop:Generator_RowDeletedName="LicitalokVevokRowDeleted" msprop:Generator_UserTableName="LicitalokVevok" msprop:Generator_RowChangedName="LicitalokVevokRowChanged" msprop:Generator_RowEvArgName="LicitalokVevokRowChangeEvent" msprop:Generator_RowClassName="LicitalokVevokRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="licit_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnlicit_id" msprop:Generator_ColumnPropNameInRow="licit_id" msprop:Generator_ColumnPropNameInTable="licit_idColumn" msprop:Generator_UserColumnName="licit_id" type="xs:int" />
              <xs:element name="idobelyeg" msprop:Generator_ColumnVarNameInTable="columnidobelyeg" msprop:Generator_ColumnPropNameInRow="idobelyeg" msprop:Generator_ColumnPropNameInTable="idobelyegColumn" msprop:Generator_UserColumnName="idobelyeg" type="xs:dateTime" />
              <xs:element name="knev" msprop:Generator_ColumnVarNameInTable="columnknev" msprop:Generator_ColumnPropNameInRow="knev" msprop:Generator_ColumnPropNameInTable="knevColumn" msprop:Generator_UserColumnName="knev">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="vnev" msprop:Generator_ColumnVarNameInTable="columnvnev" msprop:Generator_ColumnPropNameInRow="vnev" msprop:Generator_ColumnPropNameInTable="vnevColumn" msprop:Generator_UserColumnName="vnev">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="irszam" msprop:Generator_ColumnVarNameInTable="columnirszam" msprop:Generator_ColumnPropNameInRow="irszam" msprop:Generator_ColumnPropNameInTable="irszamColumn" msprop:Generator_UserColumnName="irszam">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cim" msprop:Generator_ColumnVarNameInTable="columncim" msprop:Generator_ColumnPropNameInRow="cim" msprop:Generator_ColumnPropNameInTable="cimColumn" msprop:Generator_UserColumnName="cim">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tel" msprop:Generator_ColumnVarNameInTable="columntel" msprop:Generator_ColumnPropNameInRow="tel" msprop:Generator_ColumnPropNameInTable="telColumn" msprop:Generator_UserColumnName="tel" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="varos_nev" msprop:Generator_ColumnVarNameInTable="columnvaros_nev" msprop:Generator_ColumnPropNameInRow="varos_nev" msprop:Generator_ColumnPropNameInTable="varos_nevColumn" msprop:Generator_UserColumnName="varos_nev">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="licit_ar" msprop:Generator_ColumnVarNameInTable="columnlicit_ar" msprop:Generator_ColumnPropNameInRow="licit_ar" msprop:Generator_ColumnPropNameInTable="licit_arColumn" msprop:Generator_UserColumnName="licit_ar" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:alkategoria" />
      <xs:field xpath="mstns:alkat_id" />
    </xs:unique>
    <xs:unique name="fokategoria_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:fokategoria" />
      <xs:field xpath="mstns:fokat_id" />
    </xs:unique>
    <xs:unique name="kep_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:kep" />
      <xs:field xpath="mstns:kep_id" />
    </xs:unique>
    <xs:unique name="licittargy_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:licittargy" />
      <xs:field xpath="mstns:ta_id" />
    </xs:unique>
    <xs:unique name="varos_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:varos" />
      <xs:field xpath="mstns:varos_id" />
    </xs:unique>
    <xs:unique name="felhasznalo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:felhasznalo" />
      <xs:field xpath="mstns:pw" />
      <xs:field xpath="mstns:nnev" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_alkategoria_fokategoria" msdata:parent="fokategoria" msdata:child="alkategoria" msdata:parentkey="fokat_id" msdata:childkey="fokat_id" msprop:Generator_UserChildTable="alkategoria" msprop:Generator_ChildPropName="GetalkategoriaRows" msprop:Generator_UserRelationName="FK_alkategoria_fokategoria" msprop:Generator_ParentPropName="fokategoriaRow" msprop:Generator_RelationVarName="relationFK_alkategoria_fokategoria" msprop:Generator_UserParentTable="fokategoria" />
      <msdata:Relationship name="FK_kep_licittargy" msdata:parent="licittargy" msdata:child="kep" msdata:parentkey="ta_id" msdata:childkey="ta_id" msprop:Generator_UserChildTable="kep" msprop:Generator_ChildPropName="GetkepRows" msprop:Generator_UserRelationName="FK_kep_licittargy" msprop:Generator_ParentPropName="licittargyRow" msprop:Generator_RelationVarName="relationFK_kep_licittargy" msprop:Generator_UserParentTable="licittargy" />
      <msdata:Relationship name="FK_licittargy_alkategoria" msdata:parent="alkategoria" msdata:child="licittargy" msdata:parentkey="alkat_id" msdata:childkey="alkat_id" msprop:Generator_UserChildTable="licittargy" msprop:Generator_ChildPropName="GetlicittargyRows" msprop:Generator_UserRelationName="FK_licittargy_alkategoria" msprop:Generator_RelationVarName="relationFK_licittargy_alkategoria" msprop:Generator_UserParentTable="alkategoria" msprop:Generator_ParentPropName="alkategoriaRow" />
      <msdata:Relationship name="FK_felhasznalo_varos" msdata:parent="varos" msdata:child="felhasznalo" msdata:parentkey="varos_id" msdata:childkey="varos_id" msprop:Generator_UserChildTable="felhasznalo" msprop:Generator_ChildPropName="GetfelhasznaloRows" msprop:Generator_UserRelationName="FK_felhasznalo_varos" msprop:Generator_RelationVarName="relationFK_felhasznalo_varos" msprop:Generator_UserParentTable="varos" msprop:Generator_ParentPropName="varosRow" />
      <msdata:Relationship name="FK_licit_felhasznalo" msdata:parent="felhasznalo" msdata:child="licit" msdata:parentkey="pw nnev" msdata:childkey="pw nnev" msprop:Generator_UserChildTable="licit" msprop:Generator_ChildPropName="GetlicitRows" msprop:Generator_UserRelationName="FK_licit_felhasznalo" msprop:Generator_RelationVarName="relationFK_licit_felhasznalo" msprop:Generator_UserParentTable="felhasznalo" msprop:Generator_ParentPropName="felhasznaloRowParent" />
      <msdata:Relationship name="FK_licit_licittargy" msdata:parent="licittargy" msdata:child="licit" msdata:parentkey="ta_id" msdata:childkey="ta_id" msprop:Generator_UserChildTable="licit" msprop:Generator_ChildPropName="GetlicitRows" msprop:Generator_UserRelationName="FK_licit_licittargy" msprop:Generator_RelationVarName="relationFK_licit_licittargy" msprop:Generator_UserParentTable="licittargy" msprop:Generator_ParentPropName="licittargyRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>